DELETE FROM [PipeSpecification];

DBCC CHECKIDENT ([PipeSpecification], RESEED, 0);

DECLARE @PipeDiameterTypeID int;

SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1/8';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.035,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.049,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.068,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.095,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1/4';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.049,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.088,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.119,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '3/8';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.049,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.091,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.126,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1/2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.147,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.294,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '3/4';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.113,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.154,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.308,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.133,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.179,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.358,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1 1/4';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.14,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.191,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.382,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '1 1/2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.145,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.2,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.4,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.065,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.215,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.154,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.218,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.436,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '2 1/2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.12,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.216,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.276,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.552,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '3';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.12,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.216,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.3,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.6,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '3 1/2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.108,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.12,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.226,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.318,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '4';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.12,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.2196,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.237,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.337,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.531,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.674,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '4 1/2';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.247,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.355,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '5';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.134,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.258,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '6';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.083,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.134,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.141,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.28,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.432,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.719,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.864,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '7';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.301,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '8';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.109,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.418,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.277,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.322,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'80','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.594,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.719,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.906,'160','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '9';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.342,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '10';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.134,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.156,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.165,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.279,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.307,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.365,'40','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'60','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.594,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.719,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.844,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'140','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '11';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '12';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.165,'5','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.172,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.18,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.256,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.33,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.844,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'120','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.312,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '14';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.21,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'30','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.594,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.094,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.406,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '16';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.203,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'30','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.46,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'40','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.656,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.844,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.031,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.062,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.219,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.438,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.594,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '18';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.188,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','xxs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.062,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.156,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.187,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.375,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.562,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.781,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '20';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'20','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.38,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'30','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.594,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.031,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.062,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.187,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.281,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.969,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '22';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.219,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'20','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'30','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.062,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.187,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.375,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.437,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.625,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.875,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.125,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '24';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'20','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.969,'60','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.062,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.125,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.187,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.219,'80','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.437,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.531,'100','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.812,'120','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.062,'140','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.344,'160','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '26';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '28';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '30';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '32';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '34';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '36';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.281,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'10','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','std',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'20','xs',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'30','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'40','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '38';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '40';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.312,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '42';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '44';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '46';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '48';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '50';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '52';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '54';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(3,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '56';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '60';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(3,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(3.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '64';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(3,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(3.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '68';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '72';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '76';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
SELECT @PipeDiameterTypeID = PipeDiameterTypeID FROM PipeDiameterType WHERE ShortName = '80';	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.344,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.375,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.406,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.438,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.469,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.562,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.625,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.688,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.812,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.875,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(0.938,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.25,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.5,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(1.75,'','',@PipeDiameterTypeID,'A','admin',GETDATE());
	INSERT INTO [dbo].[PipeSpecification]([WallThicknessInches],[PipeSchedule],[PipeClass],[PipeDiameterTypeID],[Active],[Creator],[Created]) VALUES(2,'','',@PipeDiameterTypeID,'A','admin',GETDATE());

SELECT * FROM [PipeSpecification];